<%@ page language="java" contentType="text/html; charset=UTF-8" import="java.sql.*" errorPage=""%>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta nnme="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>
<body>
	<jsp:useBean id="LogBean" scope="session" class="Bean.dbConn"/>
<%
request.setCharacterEncoding("UTF-8");
String myid = request.getParameter("myid");

String mynumber = request.getParameter("mynumber");
String myname = request.getParameter("myname");
String mysex = request.getParameter("mysex");
String myclass = request.getParameter("myclass");
String mybri = request.getParameter("mybri");
String mybril = request.getParameter("mybril");

	int sum = LogBean.executeUpdate("update user set number = " + "'" + mynumber + "'" + "," +
	"name = " + "'" + myname + "'" + "," +
	"sex = " + "'" + mysex + "'" + "," +
	"class = " + "'" + myclass + "'" + "," +
	"bri = " + "'" + mybri + "'" + "," +
	"bril = " + "'" + mybril + "'" + " where id = " + "'" + myid + "'");
	
	out.print("<script> alert('修改成功！'); window.location.href='testlist.jsp'; </script>");
	LogBean.closeConn();

%>

</body>
</html>